Automate workflows

Fetch Excel files from remote locations and upload to a database

Import your file

Transform your data

Upload to your storage database

Send workflow summary

1. Configure and validate source connections

   Add 'FTP' & 'Azure' storage activities. Setup the connections and specify working directories to download Excel files

   
2. Merge downloaded files

   Merge downloaded Excel files from 'Azure' and 'FTP' into a single file, using 'Read Excel File' activity

   
3. Data transformation on merged files

   Use 'Concatenate' activity to add new column that concatenates two existing columns

   
4. Upload transformed file to destination database

   Setup the 'Oracle' connection, specify tables, and map columns

   
5. Setup automated workflow summary notification

   Enable 'Send Workflow Summary' for email notifications on automated workflow execution

   
6. Schedule and monitor workflows

   Schedule or setup 'Webhooks' and 'Emails' to trigger workflows

   
7. Done